BlueCielo Meridian Enterprise Server 2016 Administrator's Guide

Appendix B: Reporting from the repository

The Meridian Explorer repository can be a data source for your favorite reporting applications. You can configure reports against the repository using any application that supports SQL Server or Oracle as a data source, for example, Microsoft SQL Server Reporting Services or SAP Crystal Reports.

The repository database includes approximately 50 interrelated tables. To simplify reporting, the repository provides predefined views upon which you can base your reports:

• Area View – Includes all projects.

• DocumentView – Includes all properties for all document revisions. Filter on the IsLatestRevision column to exclude prior revisions.

• Folder View – Includes all folders.

• ObjectTagView – Includes all properties for all asset tag revisions. Filter on the IsLatestRevision column to exclude prior revisions.

We recommend that you create reports on these views, not on the source tables. If you have special requirements that cannot be easily met using these views, contact your BlueCielo Partner or BlueCielo ECM Solutions Professional Services for more specific views.